 /****** Object:  Stored Procedure ResponsiblesGetList    Script Date: Wednesday, November 21, 2007 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spResponsibleOfficesGetListByResponsible]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spResponsibleOfficesGetListByResponsible]
GO

	
CREATE PROCEDURE spResponsibleOfficesGetListByResponsible	
	@ResponsibleID int	
AS


SELECT
	[ResponsibleOffices].[ResponsibleID],
	[ResponsibleOffices].[DefaultToOfficeID]	
FROM
	[ResponsibleOffices]
WHERE ResponsibleID = @ResponsibleID

GO

	
 